Explorer (no-code)
A no-code option to get started quickly and onboard a dataset.
.gif)
Getting Started
This page can be accessed by clicked the Explorer option (the compass icon).
.png)
Note All UI functionality has corresponding API endpoints to define, run, and get results programmatically.
Select Your Data Source
.png)
.png)
View Data is an interactive option to run queries and explore the data
The bar chart icon will take you to a profile page of the dataset created prior to Explorer 2
Select The Scope and Define a Query
.png)
Pick Date Column if your dataset contains an appropriate time filter
Click Build Model -> to Save and Continue
.png)
Transform Tab (advanced / optional)
Click Build Model -> to Save and Continue
Profile
.png)
Use the drop-downs to enable different analysis. Best practice is to leave the defaults.
Pattern (advanced / optional)
Toggle on Pattern to enable this layer.
Click +Add to define a group and series of columns.
Click Save to and Click Outlier to Continue
Outlier (advanced / optional)
Click Save to and Click Dupe to Continue
Dupe (advanced / optional)
Click Save to and Click Source to Continue
Source (advanced / optional)
Navigate to the source dataset.
Click Preview to interlace the columns.
Manually map the columns by dragging left to right or deselect columns.
Click Save to and Click Save/Run to Continue
Run
- Select an agent.
- Click Estimate Job.
- Click Run to start the job.
.png)
.png)
Note *If you do not see your agent, please verify the agent has been assigned to your connection via Adding a connection to a DQ Agent.
Terminating a DQ Job
If a DQ Job is in progress, incorrectly submitted, or stuck in Staged status, you can terminate the job by clicking the Actions drop-down list and selecting Terminate job. If you have an email address configured for alerts to be sent, two alerts are sent when a job is terminated.
Note Jobs in the Spark UI display a Finished status when terminated, even though they are terminated from the Collibra DQ UI.